Type registers a new data type for use in the current database. If a schema name is given then the type is created in the specified schema. Otherwise it is created in the current schema. The type name must be distinct from the name of any existing type or domain in the same schema. (Because tables have associated data types, the type name must also be distinct from the name of any existing table in the same schema.)
Just simply click ->
Type to open an object
pane for Type. A control-click displays the popup menu
or using the object pane toolbar below, allowing you to create new, edit and
delete the selected type.
You can create Base Type / Composite Type / Enum Type.
Note: Enum Type was added in PostgreSQL 8.3.
Create Type
To create a new type
- Select anywhere on the object pane.
- Press the
from the object pane toolbar a while to choose the type Base / Composite / Enum.
or - Control-click and select New Type from the popup menu.
- Edit type properties on the appropriate tabs of the Type Designer.
To create a new type with modification as one of the existing type
- Select the type for modifying in the object pane.
- Control-click and select the Design
Type from the popup menu or simply double-click the type.
or - Click the
from the object pane toolbar.
- Modify type properties on the appropriate tabs of the Type Designer.
- Click
Save As.
To edit the existing type(manage its general etc)
- Select the type for editing in the object pane.
- Control-click and select the Design
Type from the popup menu or simply double-click the type.
or - Click the
from the object pane toolbar.
- Edit type properties on the appropriate tabs of the Type Designer.
Delete Type
To delete a type
- Select the type for deleting in the object pane.
- Control-click and select the Delete Type
from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Achieve Type Information
To achieve a type information
- Select the type in the navigation pane/object pane.
- Choose View -> Object Information in the main menu.
or - Click the
from the object pane toolbar.